Tabela DiagnosesHistory

Definicja tabeli DiagnosesHistory

Name

DiagnosesHistory

Code

DiagnosesHistory

Comment

Tabela bedzie przechowywac historie edycji diagnoz zarówno tych na pobyt (przechowywane w LEventICD) jak i na cala hospitalizacje (NFZEpisodeData). Uzaleznione to bedzie uzupelnionym parametrem EventID lub EpisodeID.


Lista kolumn tabeli DiagnosesHistory

Name

Code

DiagnosesHistoryID

DiagnosesHistoryID

EventID

EventID

EpisodeID

EpisodeID

PersonID

PersonID

ICDID

ICDID

DiagnosisTypeID

DiagnosisTypeID

DiagnosisKindID

DiagnosisKindID

ActionTypeID

ActionTypeID

Rank

Rank

ActionDT

ActionDT

InsertingPerson

InsertingPerson

Comments

Comments

LEventICDID

LEventICDID

IsImportant

IsImportant

DiagnosisCharacterID

DiagnosisCharacterID

DiagnosisInjuryID

DiagnosisInjuryID

FirstOccurrence

FirstOccurrence

StatusID

StatusID

StatusComment

StatusComment

Commentary

Commentary


Kolumna DiagnosesHistoryID tabeli DiagnosesHistory

Definicja kolumny DiagnosesHistoryID tabeli DiagnosesHistory

Name

DiagnosesHistoryID

Code

DiagnosesHistoryID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Klucz glowny z samoinkrementacja


Kolumna EventID tabeli DiagnosesHistory

Definicja kolumny EventID tabeli DiagnosesHistory

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

Powiazanie z Eventem. gdy nie null - wpis dotyczy diagnozy na pobyt


Kolumna EpisodeID tabeli DiagnosesHistory

Definicja kolumny EpisodeID tabeli DiagnosesHistory

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Powiazanie z Episodem. gdy nie null - wpis dotyczy diagnozy na
hospitalizacje


Kolumna PersonID tabeli DiagnosesHistory

Definicja kolumny PersonID tabeli DiagnosesHistory

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

Pacjent, zwiazany z pobytem, którego dotyczy wpis (denormalizacja)


Kolumna ICDID tabeli DiagnosesHistory

Definicja kolumny ICDID tabeli DiagnosesHistory

Name

ICDID

Code

ICDID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Powiazanie z diagnoza ICD-10. dotyczy rekordów w ICD z ICDRevisionID = 1


Kolumna DiagnosisTypeID tabeli DiagnosesHistory

Definicja kolumny DiagnosisTypeID tabeli DiagnosesHistory

Name

DiagnosisTypeID

Code

DiagnosisTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Typ diagnozy


Kolumna DiagnosisKindID tabeli DiagnosesHistory

Definicja kolumny DiagnosisKindID tabeli DiagnosesHistory

Name

DiagnosisKindID

Code

DiagnosisKindID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Rodzaj diagnozy


Kolumna ActionTypeID tabeli DiagnosesHistory

Definicja kolumny ActionTypeID tabeli DiagnosesHistory

Name

ActionTypeID

Code

ActionTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Akcja uzytkownika na diagnozie (dodanie, usuniecie)


Kolumna Rank tabeli DiagnosesHistory

Definicja kolumny Rank tabeli DiagnosesHistory

Name

Rank

Code

Rank

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Flaga okreslajaca czy diagnoza byla zaznaczona do wyslania do NFZ (LEventICD.Rank)


Kolumna ActionDT tabeli DiagnosesHistory

Definicja kolumny ActionDT tabeli DiagnosesHistory

Name

ActionDT

Code

ActionDT

Data Type

DATE

Mandatory

Yes

Comment

Czas akcji


Kolumna InsertingPerson tabeli DiagnosesHistory

Definicja kolumny InsertingPerson tabeli DiagnosesHistory

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Uzytkownik, który wykonywal akcje


Kolumna Comments tabeli DiagnosesHistory

Definicja kolumny Comments tabeli DiagnosesHistory

Name

Comments

Code

Comments

Data Type

VARCHAR2(512)

Mandatory

No

Comment

Komentarz do diagnozy ICD


Kolumna LEventICDID tabeli DiagnosesHistory

Definicja kolumny LEventICDID tabeli DiagnosesHistory

Name

LEventICDID

Code

LEventICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

Historyczny klucz glówny z tabeli LEventICD


Kolumna IsImportant tabeli DiagnosesHistory

Definicja kolumny IsImportant tabeli DiagnosesHistory

Name

IsImportant

Code

IsImportant

Data Type

NUMBER(1)

Mandatory

No

Comment

Istotnosc diagnozy 0/1


Kolumna DiagnosisCharacterID tabeli DiagnosesHistory

Definicja kolumny DiagnosisCharacterID tabeli DiagnosesHistory

Name

DiagnosisCharacterID

Code

DiagnosisCharacterID

Data Type

NUMBER(10)

Mandatory

No

Comment

Charakter choroby


Kolumna DiagnosisInjuryID tabeli DiagnosesHistory

Definicja kolumny DiagnosisInjuryID tabeli DiagnosesHistory

Name

DiagnosisInjuryID

Code

DiagnosisInjuryID

Data Type

NUMBER(10)

Mandatory

No

Comment

Uraz


Kolumna FirstOccurrence tabeli DiagnosesHistory

Definicja kolumny FirstOccurrence tabeli DiagnosesHistory

Name

FirstOccurrence

Code

FirstOccurrence

Data Type

NUMBER(5)

Mandatory

Yes

Comment

Pierwszorazowa


Kolumna StatusID tabeli DiagnosesHistory

Definicja kolumny StatusID tabeli DiagnosesHistory

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

Status pacjenta na liscie


Kolumna StatusComment tabeli DiagnosesHistory

Definicja kolumny StatusComment tabeli DiagnosesHistory

Name

StatusComment

Code

StatusComment

Data Type

VARCHAR2(128)

Mandatory

No

Comment

Komentarz dotyczacy ustawienia statusu


Kolumna Commentary tabeli DiagnosesHistory

Definicja kolumny Commentary tabeli DiagnosesHistory

Name

Commentary

Code

Commentary

Data Type

CLOB

Mandatory

No

Comment

Komentarz do diagnozy


Lista kluczy tabeli DiagnosesHistory

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DiagnosesHistory

Definicja klucza Identifier_1 tabeli DiagnosesHistory

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment